After cleaning, separate Resort and City hotel

Where do the guests come from?

Home country of Guests, perform Spatial Analysis

People from all over the world are staying in these two hotels. Most guests are from Portugal and other countries in Europe

How much do guests pay for a room per night?

Both hotels have different room types and different meal arrangements. Seasonal factors are also important. So the prices vary a lot. Since no currency information is given, but Portugal is part of the European Monetary Union, I assume that all prices are in EUR.

This figure shows the average price per room, depending on its type and the standard deviation. Note that due to data anonymization rooms with the same type letter may not necessarily be the same across hotels.

How does the price per night vary over the year?

now we will observe over here is month column is not in order, & if we will visualise we will get improper conclusion

so very first we have to provide right hierarchy to the month column

This clearly shows that the prices in the Resort hotel are much higher during the summer (no surprise here). The price of the city hotel varies less and is most expensive during spring and autumn.

Distribution of Nights Spent at Hotels by Market Segment and Hotel Type

It can be seen that most of the groups are normal distributed, some of them have high skewness. Looking at the distribution, most people do not seem to prefer to stay at the hotel for more than 1 week. But it seems normal to stay in resort hotels for up to 12-13 days. It is obvious that when people go to resort hotels, they prefer to stay more.

Analysing Preference of Guests

The donut pie graph shows the meal categories. There is a big difference in the Bed & Breakfast category and the others. Almost 80% of bookings reserved for Bed&Breakfast.

Analyse Special Request done by Cuustomers¶

Around 55% of bookings do not have any special requests

City hotel customers have more special requests.

This graph is about the relationship between special requests and cancellation booking status. Nearly half bookings without any special requests have been cancelled and another half of them have not been canceled. We can also see that the more special requests the customers have the smaller the chances of cancellation.

Which are the most busy months?

Conclusion

 The City hotel has more guests during spring and autumn, when the prices are also highest.
In July and August there are less visitors, although prices are lower.

Guest numbers for the Resort hotel go down slighty from June to September, which is also when the prices are highest.
Both hotels have the fewest guests during the winter.

How long do people stay at the hotels?

As we observed before. Resort Hotel customers tend to stay more nights then City Hotel customers.

Bookings by market segment

How many bookings were cancelled?

Which month have the highest number of cancellations?

conclusion

For the City hotel the relative number of cancelations is around 40 % throughout the year.
For the Resort hotel it is highest in the summer and lowest during the winter.